To Create a One Table View

Create the view.
CREATE OR REPLACE VIEW MYVIEW

AS

SELECT AQU_POINT_P.OBJECTID, AQU_POINT_P.ID_AQU_POINT,

AQU_POINT_P.ID_REL_RELEVETERRAIN,

AQU_POINT_P.ELEVATION, AQU_POINT_P.PROVENANCEDONNEE_R,

AQU_POINT_P.GEOMETRY

FROM AQU_POINT_P
Create a primary key on the view.
ALTER VIEW MYVIEW ADD PRIMARY KEY (OBJECTID) DISABLE;
Insert the view in the Oracle Spatial metadata.
INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)

VALUES (‘MYVIEW', 'GEOMETRY',

MDSYS.SDO_DIM_ARRAY

(MDSYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),

MDSYS.SDO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)),

82247);